﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'usp_UPDMS_REF_SHOP_Insert')
	BEGIN
		DROP Procedure usp_UPDMS_REF_SHOP_Insert
	END
GO

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO
/******************************************************************************
**	Name : usp_UPDMS_REF_SHOP_Insert
**	Desc : 업소관리을 저장한다.
**	Test Exec Query : Exec usp_UPDMS_REF_SHOP_Insert
**	Called by : Ref_Dac_UPDMS_REF_SHOP.cs
**	Program ID : Ref1010m
**	Auth : 송시명
**	Date : 2013-04-04
*******************************************************************************
**	Change History
*******************************************************************************
**	Date:		Author:		Description:
**	--------	--------	---------------------------------------
**	
*******************************************************************************/
CREATE PROC [dbo].[usp_UPDMS_REF_SHOP_Insert]
@Seq int,
@Shop_Id nvarchar(5),
@Category nvarchar(5),
@Shop_Nm nvarchar(50),
@Reserve_Phone nvarchar(100),
@Address nvarchar(200),
@Latitude nvarchar(50),
@Longitude nvarchar(50),
@Favorite_Yn nvarchar(1),
@Remark nvarchar(2000),
@Create_User nvarchar(20),
@Create_Dt datetime,
@Update_User nvarchar(20),
@Update_Dt datetime
AS
SET NOCOUNT OFF

INSERT INTO UPDMS_REF_SHOP (
       Shop_Id,
       Category,
       Shop_Nm,
       Reserve_Phone,
       Address,
       Latitude,
       Longitude,
       Favorite_Yn,
       Remark,
       Create_User,
       Create_Dt,
       Update_User,
       Update_Dt
)
VALUES (
       @Shop_Id,
       @Category,
       @Shop_Nm,
       @Reserve_Phone,
       @Address,
       @Latitude,
       @Longitude,
       @Favorite_Yn,
       @Remark,
       @Create_User,
       GETDATE(),
       @Update_User,
       GETDATE()
)

GO